<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>JdbcSlimRunner xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../testapidocs/uk/co/javahelp/fitnesse/slim/JdbcSlimRunner.html">View Javadoc</a></div><pre>

<a class="jxr_linenumber" name="1" href="#1">1</a>   <strong class="jxr_keyword">package</strong> uk.co.javahelp.fitnesse.slim;
<a class="jxr_linenumber" name="2" href="#2">2</a>   
<a class="jxr_linenumber" name="3" href="#3">3</a>   <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> java.util.Arrays.asList;
<a class="jxr_linenumber" name="4" href="#4">4</a>   
<a class="jxr_linenumber" name="5" href="#5">5</a>   <strong class="jxr_keyword">import</strong> java.util.ArrayList;
<a class="jxr_linenumber" name="6" href="#6">6</a>   <strong class="jxr_keyword">import</strong> java.util.List;
<a class="jxr_linenumber" name="7" href="#7">7</a>   <strong class="jxr_keyword">import</strong> java.util.Map;
<a class="jxr_linenumber" name="8" href="#8">8</a>   
<a class="jxr_linenumber" name="9" href="#9">9</a>   <strong class="jxr_keyword">import</strong> org.springframework.jdbc.core.JdbcTemplate;
<a class="jxr_linenumber" name="10" href="#10">10</a>  <strong class="jxr_keyword">import</strong> org.springframework.jdbc.datasource.SingleConnectionDataSource;
<a class="jxr_linenumber" name="11" href="#11">11</a>  
<a class="jxr_linenumber" name="12" href="#12">12</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../uk/co/javahelp/fitnesse/slim/JdbcSlimRunner.html">JdbcSlimRunner</a> {
<a class="jxr_linenumber" name="13" href="#13">13</a>  
<a class="jxr_linenumber" name="14" href="#14">14</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> JdbcTemplate template;
<a class="jxr_linenumber" name="15" href="#15">15</a>  	
<a class="jxr_linenumber" name="16" href="#16">16</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String sql;
<a class="jxr_linenumber" name="17" href="#17">17</a>  
<a class="jxr_linenumber" name="18" href="#18">18</a>  	<strong class="jxr_keyword">public</strong> <a href="../../../../../uk/co/javahelp/fitnesse/slim/JdbcSlimRunner.html">JdbcSlimRunner</a>(<strong class="jxr_keyword">final</strong> String driverClassname, <strong class="jxr_keyword">final</strong> String url, <strong class="jxr_keyword">final</strong> String username, <strong class="jxr_keyword">final</strong> String password, <strong class="jxr_keyword">final</strong> String sql)
<a class="jxr_linenumber" name="19" href="#19">19</a>  	        <strong class="jxr_keyword">throws</strong> ClassNotFoundException {
<a class="jxr_linenumber" name="20" href="#20">20</a>  		Class.forName(driverClassname);
<a class="jxr_linenumber" name="21" href="#21">21</a>  		<strong class="jxr_keyword">this</strong>.template = <strong class="jxr_keyword">new</strong> JdbcTemplate(<strong class="jxr_keyword">new</strong> SingleConnectionDataSource(url, username, password, false));
<a class="jxr_linenumber" name="22" href="#22">22</a>  		<strong class="jxr_keyword">this</strong>.sql = sql;
<a class="jxr_linenumber" name="23" href="#23">23</a>  	}
<a class="jxr_linenumber" name="24" href="#24">24</a>  	
<a class="jxr_linenumber" name="25" href="#25">25</a>  	<strong class="jxr_keyword">public</strong> List&lt;Object&gt; query() {
<a class="jxr_linenumber" name="26" href="#26">26</a>  		<strong class="jxr_keyword">final</strong> List&lt;Object&gt; rows = <strong class="jxr_keyword">new</strong> ArrayList&lt;Object&gt;();
<a class="jxr_linenumber" name="27" href="#27">27</a>  		<strong class="jxr_keyword">final</strong> List&lt;Map&lt;String, Object&gt;&gt; dbRows = <strong class="jxr_keyword">this</strong>.template.queryForList(<strong class="jxr_keyword">this</strong>.sql);
<a class="jxr_linenumber" name="28" href="#28">28</a>  		<strong class="jxr_keyword">for</strong>(Map&lt;String, Object&gt; dbRow : dbRows) {
<a class="jxr_linenumber" name="29" href="#29">29</a>      		<strong class="jxr_keyword">final</strong> List&lt;List&lt;Object&gt;&gt; row = <strong class="jxr_keyword">new</strong> ArrayList&lt;List&lt;Object&gt;&gt;();
<a class="jxr_linenumber" name="30" href="#30">30</a>  			<strong class="jxr_keyword">for</strong>(Map.Entry&lt;String, Object&gt; dbCell : dbRow.entrySet()) {
<a class="jxr_linenumber" name="31" href="#31">31</a>  				row.add(asList(dbCell.getKey(), dbCell.getValue()));
<a class="jxr_linenumber" name="32" href="#32">32</a>  			}
<a class="jxr_linenumber" name="33" href="#33">33</a>  			rows.add(row);
<a class="jxr_linenumber" name="34" href="#34">34</a>  		}
<a class="jxr_linenumber" name="35" href="#35">35</a>  		<strong class="jxr_keyword">return</strong> rows;
<a class="jxr_linenumber" name="36" href="#36">36</a>  	}
<a class="jxr_linenumber" name="37" href="#37">37</a>  }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

